HCA 542: Health Care Database Design and Management
Assignment IV
Your task
Panther Memorial has been please with your work and now would like you to develop a data entry forms and a report
for the database.
Deliverables
A Microsoft Access database that contains your implementation of the data entry form and report that adheres to the
instructions provided.
Starter Database
When starting your project, download the Panther Memorial Starter Database from D2L and then add to this database.
Start with a brand new database download. DO NOT use your Assignment III database.
Individual work
This assignment will be completed individually without collaboration with other students.
Submission
Submit your assignment to the D2L dropbox by 11:55 on the due date in the course schedule on D2L.
The deliverable will be submitted via the D2L dropbox. It is your responsibility to correctly submit the entire assignment
on time in D2L. To ensure that your items are correctly uploaded, reopen your files from the D2L dropbox to test it.
Note that checking your submission is especially important with an Access database to ensure that you uploaded the
actual database file (*.aacdb) file and not the security file (*.laccdb).
Grading
This project is worth 100 points.
Data entry form (55 points total)
10 pts Fields and Labels
2 pts Form Title
6 pts Aesthetics
5 pts Ability to successfully enter a complete record
12 pts Dropdowns
16 pts Sub-forms
4 pts Navigation Button
Report (45 points total)
10 pts Fields and Labels
5 pts Aesthetics
10 pts Grouping
5 pts Alternate Row Highlighting
5 pts Total Field
5 pts Page Breaks
5 pts Date and Time in Footer
Data Entry Form
Create the form as shown. Note that you need to create all of the form elements (boxes, buttons, etc). For example,
the close button should perform as expected and closes the form.
Create dropdown (combo) boxes for any referenced table. For example, use Unit ID to link to the Unit table in order to
display the Unit Name in the dropdown.
Problems and orders are contained in a subform. You may find it easier to create the subforms separately and then add
them to your form.
Be sure to test your form by creating a new patient visit and entering information into each and every data field
including the subforms. A form that does not successfully permit data entry is not a useful data entry form.

Reports
Create a report that produces patient bills such as the example page shown. Note that you need to create all of the
report elements (boxes, lines, bolding, alternate row highlighting, etc).
You may find it easier to create the query for the report first and then use that query as the data source for the report.
The report has a page header which contains the hospital name and address implemented as labels and a line. The
group header contains the patient/visit information and the labels regarding the treatment. The total charges are in a
group footer. The detail section simply holds the text boxes regarding treatments.
To create the sum, look at the group you created on Visit ID. In the group properties, one of the options will read “with
no totals”. Change this to sum on Amount Charged at the footer level.
Note that each bill must appear on its own page in print preview (as you would expect for a real bill). Note that a bill is
produced for each visit, not each patient.
Patient Bill (Page 3 of the Print Preview)

HCA 542: Health Care Database Design and Management
Assignment IV
Your task
Panther Memorial has been please with your work and now would like you to develop a data entry forms and a report
for the database.
Deliverables
A Microsoft Access database that contains your implementation of the data entry form and report that adheres to the
instructions provided.
Starter Database
When starting your project, download the Panther Memorial Starter Database from D2L and then add to this database.
Start with a brand new database download. DO NOT use your Assignment III database.
Individual work
This assignment will be completed individually without collaboration with other students.
Submission
Submit your assignment to the D2L dropbox by 11:55 on the due date in the course schedule on D2L.
The deliverable will be submitted via the D2L dropbox. It is your responsibility to correctly submit the entire assignment
on time in D2L. To ensure that your items are correctly uploaded, reopen your files from the D2L dropbox to test it.
Note that checking your submission is especially important with an Access database to ensure that you uploaded the
actual database file (*.aacdb) file and not the security file (*.laccdb).
Grading
This project is worth 100 points.
Data entry form (55 points total)
10 pts Fields and Labels
2 pts Form Title
6 pts Aesthetics
5 pts Ability to successfully enter a complete record
12 pts Dropdowns
16 pts Sub-forms
4 pts Navigation Button
Report (45 points total)
10 pts Fields and Labels
5 pts Aesthetics
10 pts Grouping
5 pts Alternate Row Highlighting
5 pts Total Field
5 pts Page Breaks
5 pts Date and Time in Footer
Data Entry Form
Create the form as shown. Note that you need to create all of the form elements (boxes, buttons, etc). For example,
the close button should perform as expected and closes the form.
Create dropdown (combo) boxes for any referenced table. For example, use Unit ID to link to the Unit table in order to
display the Unit Name in the dropdown.
Problems and orders are contained in a subform. You may find it easier to create the subforms separately and then add
them to your form.
Be sure to test your form by creating a new patient visit and entering information into each and every data field
including the subforms. A form that does not successfully permit data entry is not a useful data entry form.

Reports
Create a report that produces patient bills such as the example page shown. Note that you need to create all of the
report elements (boxes, lines, bolding, alternate row highlighting, etc).
You may find it easier to create the query for the report first and then use that query as the data source for the report.
The report has a page header which contains the hospital name and address implemented as labels and a line. The
group header contains the patient/visit information and the labels regarding the treatment. The total charges are in a
group footer. The detail section simply holds the text boxes regarding treatments.
To create the sum, look at the group you created on Visit ID. In the group properties, one of the options will read “with
no totals”. Change this to sum on Amount Charged at the footer level.
Note that each bill must appear on its own page in print preview (as you would expect for a real bill). Note that a bill is
produced for each visit, not each patient.
Patient Bill (Page 3 of the Print Preview)